package com.engineering.elink.recruitdao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.engineering.elink.domain.recruit.ProfessionalDetailCategory;

public interface ProfessionalDetailCategoryMapper {
    int deleteByPrimaryKey(Integer pdcId);

    int insert(ProfessionalDetailCategory record);

    int insertSelective(ProfessionalDetailCategory record);

    ProfessionalDetailCategory selectByPrimaryKey(Integer pdcId);

    int updateByPrimaryKeySelective(ProfessionalDetailCategory record);

    int updateByPrimaryKey(ProfessionalDetailCategory record);
    
    @Select(" select pdc_id as pdcId, msc_id as mscId, pdc_name as pdcName from professional_detail_category where msc_id=#{mscId} ")
    List<ProfessionalDetailCategory> selectAllByMscId(Integer mscId);
}